Tabela DrugSynonym

Definicja tabeli DrugSynonym

Name

DrugSynonym

Code

DrugSynonym

Comment

Slownik nazw zbiorów synonimów zbiorczych


Lista kolumn tabeli DrugSynonym

Name

Code

DrugSynonymID

DrugSynonymID

Name

Name

SummarySynonym

SummarySynonym

HashCode

HashCode

LastModifiedDT

LastModifiedDT


Kolumna DrugSynonymID tabeli DrugSynonym

Definicja kolumny DrugSynonymID tabeli DrugSynonym

Name

DrugSynonymID

Code

DrugSynonymID

Data Type

VARCHAR2(6)

Mandatory

Yes

Comment

 


Kolumna Name tabeli DrugSynonym

Definicja kolumny Name tabeli DrugSynonym

Name

Name

Code

Name

Data Type

VARCHAR2(256)

Mandatory

No

Comment

Nazwa


Kolumna SummarySynonym tabeli DrugSynonym

Definicja kolumny SummarySynonym tabeli DrugSynonym

Name

SummarySynonym

Code

SummarySynonym

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Synonim zbiorczy


Kolumna HashCode tabeli DrugSynonym

Definicja kolumny HashCode tabeli DrugSynonym

Name

HashCode

Code

HashCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kod MD5 tworzony na podstawie danych z wszystkich kolumn tabeli


Kolumna LastModifiedDT tabeli DrugSynonym

Definicja kolumny LastModifiedDT tabeli DrugSynonym

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Lista kluczy tabeli DrugSynonym

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DrugSynonym

Definicja klucza Identifier_1 tabeli DrugSynonym

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment